/**
 * 
 */
package com.orange.handler;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import com.orange.dbhelp.page.Page;
import com.orange.modules.entity.AuthItem;
import com.orange.modules.entity.expert.AuthExportGroupMap;
import com.orange.modules.entity.expert.AuthGroup;
import com.orange.modules.entity.school.AuthSchool;
import com.orange.modules.bean.ExpertGroupBean;
/**
 * @author gaogs
 *
 * 2016-11-16
 */
public interface AuthExportGroupService {
	
	/**
	 * 保存专家组信息
	 * @param a
	 */
	public void saveAuthExportGroupInfo(AuthGroup a);

	public AuthGroup queryAuthExportGroupInfo(String pid) throws SQLException;
	
	public void addAuthExportGroupMap(AuthExportGroupMap a);
	
	public Page<ExpertGroupBean> queryAuthExportGroupMapInfo(Integer pageNumber,Integer pageSize , Map<String ,String> map) throws SQLException;

	public List<AuthExportGroupMap> queryAuthExportGroupIdentity() throws SQLException;
	
	public List<AuthExportGroupMap> queryAuthExportGroupExportId() throws SQLException;
	

	// 删除组
	public void deleteAuhExportGroupInfo(String pid) throws SQLException;

	// 一个专家只能绑定一个学校
	public AuthGroup queryAuthGroupBySchoolId(String pid) throws SQLException;

	
	/**
	 * 分页查询现场考察专家组
	 * @param map
	 * @return
	 * @throws SQLException
	 */
	public Page<AuthGroup> queryAuthGroupPage(Map<String,String>map) throws SQLException;

	/**
	 * 分页查询材料评审专家组
	 * 
	 * @param map
	 * @return
	 * @throws SQLException
	 */
	public Page<AuthGroup> queryAuthGroupPage_material(Map<String, String> map) throws SQLException;
	
	/**
	 * 填报数据查询(绑定)
	 */
	public Page<AuthSchool> queryAuthObservationSchool(String expertId ,Map<String, String> map) throws SQLException;
	
	/**
	 * 查询学校Id
	 */
	public AuthSchool querySchoolIdByExpertId(String expertId) throws SQLException;
	
	/**
	 * 根据学校id查询该校材料评审结果
	 */
	public List<AuthItem> queryAuthmaterialResultBySchoolId(String schoolId) throws SQLException;
	
	/**
	 * 查询专家id根据组id
	 */
	public List<AuthExportGroupMap> queryAuthExportGroupExportIdByGroupId(String groupId) throws SQLException;
	
	
	
	
}
